Tabela LStockDocumentIdentifier

Definicja tabeli LStockDocumentIdentifier

Name

LStockDocumentIdentifier

Code

LStockDocumentIdentifier

Comment

Dodatkowe numery dla dokumentów magazynowych StockDocument


Lista kolumn tabeli LStockDocumentIdentifier

Name

Code

IdentifierTypeID

IdentifierTypeID

StockDocumentID

StockDocumentID

ExternalValue

ExternalValue

Active

Active

InsertingPerson

InsertingPerson

InsertDate

InsertDate

LastModifiedPerson

LastModifiedPerson

LastModifiedDT

LastModifiedDT


Kolumna IdentifierTypeID tabeli LStockDocumentIdentifier

Definicja kolumny IdentifierTypeID tabeli LStockDocumentIdentifier

Name

IdentifierTypeID

Code

IdentifierTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StockDocumentID tabeli LStockDocumentIdentifier

Definicja kolumny StockDocumentID tabeli LStockDocumentIdentifier

Name

StockDocumentID

Code

StockDocumentID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ExternalValue tabeli LStockDocumentIdentifier

Definicja kolumny ExternalValue tabeli LStockDocumentIdentifier

Name

ExternalValue

Code

ExternalValue

Data Type

VARCHAR2(64)

Mandatory

Yes

Comment

 


Kolumna Active tabeli LStockDocumentIdentifier

Definicja kolumny Active tabeli LStockDocumentIdentifier

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna InsertingPerson tabeli LStockDocumentIdentifier

Definicja kolumny InsertingPerson tabeli LStockDocumentIdentifier

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna InsertDate tabeli LStockDocumentIdentifier

Definicja kolumny InsertDate tabeli LStockDocumentIdentifier

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna LastModifiedPerson tabeli LStockDocumentIdentifier

Definicja kolumny LastModifiedPerson tabeli LStockDocumentIdentifier

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LastModifiedDT tabeli LStockDocumentIdentifier

Definicja kolumny LastModifiedDT tabeli LStockDocumentIdentifier

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Lista kluczy tabeli LStockDocumentIdentifier

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LStockDocumentIdentifier

Definicja klucza Identifier_1 tabeli LStockDocumentIdentifier

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment